package dbutils

const UserTable = `CREATE TABLE if not exists user (
    id INT(10) NOT NULL AUTO_INCREMENT,
    phone VARCHAR(64) NULL DEFAULT NULL,
    pwd VARCHAR(64) NULL DEFAULT NULL,
	name VARCHAR(64) NULL DEFAULT '未设置名称',
	portrait VARCHAR(64) NULL DEFAULT NULL COMMENT '头像',
    created timestamp not null default current_timestamp,
    PRIMARY KEY (id)
)`
